﻿Notes on RM5 Database Structure

For backing up and classifying media files:

MultimediaTable
	MediaPath: string with path and no filename
	MediaFile: string with file name but no path

For dealing with named groups:

GroupTable
	RecID: integer for primary index
	GroupID: integer identifier for group which has record(s)
	StartID: integer first record of range of records in group
	EndID: integer last record of range of records in group (could equal StartID)

LabelTable
	LabelID: integer for primary index
	LabelType: integer
		0 for group name in group table
	LabelValue: integer
		for group name, this matches the GroupID in GroupTable
	LabelName: string, text of label
	Description: blob, (unused as far as I can tell)

For Tracing Tree
	PersonTable
		Stores basic data for persons in tree: globally Unique ID as well as internal PersonID,
		FamilyID of parent family and PersonID of spouse, calculated relationship to other person in tree,
		privacy and living flags, and general note.

	FamilyTable
		Stores Family pairings, spousal order, and notes.

	ChildTable
		Stores relationship to family(ies) for each child.
		A child may have two or more families – e.g., birth and adoptive.
		Links to PersonTable for child and to FamilyTable for parents.